<!--
  This file is a part of the open-eBackup project.
  This Source Code Form is subject to the terms of the Mozilla Public License, v. 2.0.
  If a copy of the MPL was not distributed with this file, You can obtain one at
  http://mozilla.org/MPL/2.0/.
  
  Copyright (c) [2024] Huawei Technologies Co.,Ltd.
  
  THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
  EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
  MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
  -->


<!DOCTYPE html
  PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="zh-cn" xml:lang="zh-cn">
<head>
      <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="DC.Type" content="topic">
<meta name="DC.Title" content="备份前准备">
<meta name="product" content="">
<meta name="DC.Relation" scheme="URI" content="SAP_HANA_0007.html">
<meta name="prodname" content="">
<meta name="version" content="">
<meta name="brand" content="">
<meta name="DC.Publisher" content="20250306">
<meta name="prodname" content="csbs">
<meta name="documenttype" content="usermanual">
<meta name="DC.Format" content="XHTML">
<meta name="DC.Identifier" content="SAP_HANA_0010">
<meta name="DC.Language" content="zh-cn">
<link rel="stylesheet" type="text/css" href="public_sys-resources/commonltr.css">
<title>备份前准备</title>
</head>
<body style="clear:both; padding-left:10px; padding-top:5px; padding-right:5px; padding-bottom:5px"><a name="SAP_HANA_0010"></a><a name="SAP_HANA_0010"></a>

<h1 class="topictitle1">备份前准备</h1>
<div><ul><li>备份SAP HANA数据库前，请确保<span style="color:#414142;">客户端所在主机有足够的硬件资源</span>（<span style="color:#404040;">内存、CPU、存储等</span>）。建议您使用安装<span style="color:#414142;">SAP HANA数据库后系统</span>自带的Quick Sizer工具，评估主机运行时的硬件需求。通过<span style="color:#404040;">分析用户输入的业务场景数据</span>，<span style="color:#404040;">生成对内存、CPU、存储等关键资源的建议配置</span>。您可以访问<a href="https://www.sap.com/about/benchmark/sizing.quick-sizer.html#quick-sizer" target="_blank" rel="noopener noreferrer">quick-sizer</a>获取相关的指导。</li><li>对SAP HANA数据库所包含的系统数据库和各个租户数据库进行备份前，请参考<a href="#SAP_HANA_0010__zh-cn_topic_0000001455091930_table10744125193920">表1</a>提前准备相关的配置信息。
<div class="tablenoborder"><a name="SAP_HANA_0010__zh-cn_topic_0000001455091930_table10744125193920"></a><a name="zh-cn_topic_0000001455091930_table10744125193920"></a><table cellpadding="4" cellspacing="0" summary="" id="SAP_HANA_0010__zh-cn_topic_0000001455091930_table10744125193920" frame="border" border="1" rules="all"><caption><b>表1 </b>备份前准备</caption><colgroup><col style="width:17.34%"><col style="width:54.61%"><col style="width:16.34%"></colgroup><thead align="left"><tr><th align="left" class="cellrowborder" valign="top" width="19.63982330954808%" id="mcps1.3.1.2.2.2.4.1.1"><p>准备项</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="61.8529844829539%" id="mcps1.3.1.2.2.2.4.1.2"><p>获取方式</p>
</th>
<th align="left" class="cellrowborder" valign="top" width="18.507192207498015%" id="mcps1.3.1.2.2.2.4.1.3"><p>数据使用章节</p>
</th>
</tr>
</thead>
<tbody><tr><td class="cellrowborder" valign="top" width="19.63982330954808%" headers="mcps1.3.1.2.2.2.4.1.1 "><p>系统数据库名称、租户数据库名称与SAP HANA数据库的实例ID</p>
</td>
<td class="cellrowborder" valign="top" width="61.8529844829539%" headers="mcps1.3.1.2.2.2.4.1.2 "><div class="p">数据库名称和SAP HANA数据库的实例ID可通过以下方式查询：<ol><li>使用PuTTY登录SAP HANA数据库所在的任意一个主机。</li><li>执行以下命令，切换SAP系统用户<em>“&lt;sid&gt;</em>adm<em>”</em>并进入系统数据库，以用户名<strong>s00adm</strong>为例。<div class="note"><span class="notetitle"> 说明： </span><div class="notebody"><p>&lt;sid&gt;adm是SAP系统用户，其中&lt;sid&gt;代表SAP系统ID（System ID），是SAP HANA系统安装时定义的一个由字母或数字组成的3位编号，用于唯一标识一个SAP HANA系统。adm是管理员（administrator）的缩写，表示这是一个用于系统管理的用户。</p>
</div></div>
<pre class="screen">su - <em>s00adm</em>
hdbsql -i 00 -n localhost:30013 -d SYSTEMDB -u SYSTEM -p <em></em><em>系统数据库默认用户SYSTEM的密码;</em></pre>
</li><li>执行以下命令，查询系统数据库名称、租户数据库名称与SAP HANA数据库实例ID。<pre class="screen">SELECT * FROM M_DATABASES;</pre>
<p>回显类似如下，其中<strong>SYSTEMDB</strong>是系统数据库名称，<strong>S00</strong>是SAP HANA数据库实例ID，<strong>T00</strong>是租户数据库名称。</p>
<pre class="screen">DATABASE_NAME,DESCRIPTION,ACTIVE_STATUS,ACTIVE_STATUS_DETAILS,OS_USER,OS_GROUP,RESTART_MODE
"SYSTEMDB","SystemDB-S00-00","YES","","","","DEFAULT"
"T00","","YES","","","","DEFAULT"</pre>
</li></ol>
</div>
</td>
<td class="cellrowborder" rowspan="5" valign="top" width="18.507192207498015%" headers="mcps1.3.1.2.2.2.4.1.3 "><p><a href="SAP_HANA_0012-1.html">注册系统数据库</a></p>
<p><a href="SAP_HANA_0020-1.html">注册系统数据库</a></p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.4.1.1 "><p>数据库主机</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.4.1.2 "><p>系统数据库所在的主机和各个租户数据库所在的主机。</p>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.4.1.1 "><p>租户数据库用户名及密码</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.4.1.2 "><p>访问要保护的租户数据库的用户名及其密码。</p>
<div class="note"><span class="notetitle"> 说明： </span><div class="notebody"><p>租户数据库的默认用户为“SYSTEM”，您也可以参见<a href="SAP_HANA_0112-1.html">如何为系统数据库和租户数据库创建新的用户</a>为租户数据库创建其他的用户。</p>
</div></div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.4.1.1 "><p>系统数据库用户名及密码</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.4.1.2 "><p>访问要保护的系统数据库的用户名及其密码。</p>
<div class="note"><span class="notetitle"> 说明： </span><div class="notebody"><p>系统数据库的默认用户为“SYSTEM”，您也可以参见<a href="SAP_HANA_0112-1.html">如何为系统数据库和租户数据库创建新的用户</a>为系统数据库创建其他的用户。</p>
</div></div>
</td>
</tr>
<tr><td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.4.1.1 "><p>SAP HANA数据库的systemId及SQL Port</p>
</td>
<td class="cellrowborder" valign="top" headers="mcps1.3.1.2.2.2.4.1.2 "><ul><li>systemId可在SAP HANA Studio上查询，如下所示：<p><span><img src="zh-cn_image_0000002164828502.png"></span></p>
</li><li>SQL Port：系统数据库master节点的SQL Port，可在SAP HANA Studio上查询。<p>单租户模式下，默认SQL Port为30015；多租户模式下，默认SQL Port为30013。</p>
</li></ul>
</td>
</tr>
</tbody>
</table>
</div>
</li></ul>
</div>
<div>
<div class="familylinks">
<div class="parentlink"><strong>父主题：</strong> <a href="SAP_HANA_0007.html">备份</a></div>
</div>
</div>

<div class="hrcopyright"><hr size="2"></div><div class="hwcopyright">版权所有 &copy; 华为技术有限公司</div></body>
</html>